create table pvNiveles(
	Nivel varchar(3) not null primary key,
	Sueldo decimal(18,2) not null,
	BonoPuntualidad decimal(18,2) not null,
	BonoAsistencia decimal(18,2) not null,
	PrimaDominial decimal(18,2) not null,
	Bono decimal(18,2) not null, 
	ComisionLimite decimal(18,2) not null,
	ComisionPorcentaje decimal(18,2) not null
)
go

insert into pvNiveles values ('E1',3500, 250, 250, 0, 0, 150000, 1.5)
go
insert into pvNiveles values ('E2',3500, 350, 350, 0, 800, 200000, 1.5)
go
insert into pvNiveles values ('E3',4000, 350, 350, 0, 1300, 275000, 1.5)
go
insert into pvNiveles values ('E4',4000, 350, 350, 0, 2300, 375000, 1.5)
go
insert into pvNiveles values ('V3',2500, 200, 200, 100, 0, 130000, 1.5)
go
insert into pvNiveles values ('V4',2500, 300, 300, 100, 0, 150000, 1.5)
go
insert into pvNiveles values ('S1',5000, 500, 500, 0, 0, 150000, 1.5)
go
insert into pvNiveles values ('S2',5000, 500, 500, 0, 1000, 150000, 1.5)
go